  Use master
  GO

  IF EXISTS (SELECT * FROM sysdatabases WHERE NAME ='TRACK_MAILING')
  BEGIN
    ALTER DATABASE TRACK_MAILING SET SINGLE_USER WITH ROLLBACK IMMEDIATE
    Drop database TRACK_MAILING
  END
  GO
   
  Use master
  GO
  Create database TRACK_MAILING
  COLLATE SQL_Latin1_General_CP850_CS_AS -- or any collation you require
  GO
  
  use TRACK_MAILING
  GO
  
    create table track (
      [id] [bigint] IDENTITY (1, 1) NOT NULL PRIMARY KEY,
      [cine] [varchar] (20) NOT NULL,
      [codigo_transaccion] [varchar] (100) NOT NULL,
      [numero_boleta] [varchar] (100)  NULL,
      [email] [varchar] (150)  NULL,
      [path_archivo] [varchar] (100)  NULL,
      [accion] [varchar] (10) NOT NULL,
      [accion_exitosa] bit NOT NULL,
      [excepcion] [varchar] (500) NULL,
      [create_date] [datetime] default getDate()
  )
  GO